﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using FileHelpers;

namespace TableStructures
{
    [DelimitedRecord(",")]
    public class CityCategory
    {
        public String CityName;
        public String State;
        public String Category;
    }

    [DelimitedRecord(",")]
    public class CarSalesData
    {
        public UInt64 AGREEMENTID;
        public String AGREEMENTNO;
        [FieldConverter(ConverterKind.Date, "dd-MMM-yy")]
        public DateTime AGREEMENTDATE;
        [FieldConverter(ConverterKind.Date, "dd-MMM-yy")]
        public DateTime DISB_DATE;
        public UInt64 DISBURSALAMOUNT;
        public UInt64 DISB_AMT;
        public UInt64 AMTFIN;
        public Double PRETAXIRR; //DOUBLE
        public UInt64 LESSEEID;
        public UInt64 TENURE;
        public UInt64 EMI;
        public String FILENO;
        public String BRANCHNM;
        public String MODELNO;
        public String MANUFACTURERDESC;
        public String NAME;
        public String DEALERNAME;
        public UInt64 ADVANCEINSTL;
        public UInt64 PROCESSINGFEE;
        public UInt64 MFR_SUBVENTION_IN;
        public UInt64 MFR_SUBVENTION_PAID;
        public UInt64 DEALER_SUBVENTION;
        public UInt64 DMA_SUBVENTION;
        public String PROMOTIONDESC;
        public Double MARGINMONEY; //DOUBLE
        public UInt64 ADVANCE_EMI;
        public String EMPLOYERNAME;
        public String STATUS;
        public String MAKE;
        public String V_ASSET_CATG;
        public String PRODUCTFLAG;
        public String BRANCH_CODE;
        public UInt64 DMABROKERCODE;
        public String SCHEMECODE;
        public String PROMOTIONSCHEME;
        public Double EFFRATE; //DOUBLE
        public UInt64 MODELCODE;
        public UInt64 SUBMODELCODE;
        public Double GROSS_LTV; //DOUBLE
        public Double NET_LTV; //DOUBLE
        public String FINALSOURCE;
        public String FIRSTSOURCE;
        public String CUSTCATG;
        public UInt64 DMA_SUBVENTION_NOT_DED;
        public String EMPTYPE;
        public UInt64 CFOC;
        public String STATE;
        public String CHANNELCODE;
        public UInt64 MANUFACTURERID;
        [FieldNullValue(typeof(UInt64), "0")]
        public UInt64 EMPLOYERID;
        [FieldQuoted('"', QuoteMode.OptionalForBoth)]
        public String INFAVOUROF;
        public String CHEQUESTATUS;
        public String OSP_CODE;
        public String DME_NAME;
        public String DUMMY;
        public String CUSTOMER_NAME;
        public String PAYMENT_MODE;
    }

    [DelimitedRecord(",")]
    public class DMAMaster
    { 
        public String Product;
        public String BrokerCode;
        public String DmaType;
        public String poBranch;
        public String DmaName;
        public UInt64 IBoxId;
        public String PanNo;
        public UInt64 AccountNo;
        public String IFSCCode;
        public String MOP;
        public String SAPCode;
    }

    [DelimitedRecord(",")]
    public class Segments
    {
        public String Make;
        public String ModelNo;
        public String Manufacturer;
        public String Segment;
    }

    [DelimitedRecord(",")]
    public class Source
    {
        public String FinalSource;
        public String FirstSource;
        public String EmpType;
    }

    [DelimitedRecord(",")]
    public class GenTable
    {
        public String Value;
    }

    [DelimitedRecord(",")]
    public class AgentMaster
    {
        public UInt64 SrNo;
        public String APS_OSPCode;
        public String EmpCode;
        public String CounVendorCode;
        public String RetainerName;
        public UInt64 GrossFixedPayout;
        public DateTime DateOfResignation;
        public String MainDesignation;
        public String Designation;
        public String Product;
        public String AgencyName;
        public String Zone;
        public String Region;
        public String Location;
        public String State;
        public String ModeOfPayment;
        public UInt64 BankAccountNo;
        public String BranchMICRCode;
        public String BranchIFSCCode;
        public String BranchName;
        public String VSTS_Id;
        public String VSTS_Status;
        public String PAN_NO;
        public String IBoxId;
        public String AgreementStatus;
        public DateTime DateOfJoining;
    }

    [DelimitedRecord(",")]
    public class TaxMaster
    {
        public UInt64 RowNo;
    }


}
